Tabela ReferralOrgUnit

Definicja tabeli ReferralOrgUnit

Name

ReferralOrgUnit

Code

ReferralOrgUnit

Comment

 


Lista kolumn tabeli ReferralOrgUnit

Name

Code

ReferralOrgUnitID

ReferralOrgUnitID

Code

Code

CompanyStatisticalNo

CompanyStatisticalNo

ContractNo

ContractNo

FullName

FullName

TaxPayerID

TaxPayerID

City

City

Street

Street

PostCode

PostCode

StatCode

StatCode

StatCode8

StatCode8


Kolumna ReferralOrgUnitID tabeli ReferralOrgUnit

Definicja kolumny ReferralOrgUnitID tabeli ReferralOrgUnit

Name

ReferralOrgUnitID

Code

ReferralOrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli ReferralOrgUnit

Definicja kolumny Code tabeli ReferralOrgUnit

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli ReferralOrgUnit

Definicja kolumny CompanyStatisticalNo tabeli ReferralOrgUnit

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ContractNo tabeli ReferralOrgUnit

Definicja kolumny ContractNo tabeli ReferralOrgUnit

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna FullName tabeli ReferralOrgUnit

Definicja kolumny FullName tabeli ReferralOrgUnit

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli ReferralOrgUnit

Definicja kolumny TaxPayerID tabeli ReferralOrgUnit

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna City tabeli ReferralOrgUnit

Definicja kolumny City tabeli ReferralOrgUnit

Name

City

Code

City

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Street tabeli ReferralOrgUnit

Definicja kolumny Street tabeli ReferralOrgUnit

Name

Street

Code

Street

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna PostCode tabeli ReferralOrgUnit

Definicja kolumny PostCode tabeli ReferralOrgUnit

Name

PostCode

Code

PostCode

Data Type

VARCHAR2(6)

Mandatory

No

Comment

 


Kolumna StatCode tabeli ReferralOrgUnit

Definicja kolumny StatCode tabeli ReferralOrgUnit

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StatCode8 tabeli ReferralOrgUnit

Definicja kolumny StatCode8 tabeli ReferralOrgUnit

Name

StatCode8

Code

StatCode8

Data Type

VARCHAR2(4)

Mandatory

No

Comment

VIII czesc kodu resortowego jednostki zlecajacej


Lista kluczy tabeli ReferralOrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ReferralOrgUnit

Definicja klucza Identifier_1 tabeli ReferralOrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment